Information Technology - Database Languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) (Adopted ISO/IEC 9075-4:2003, third edition, 2003-12-15), Includes Technical Corrigendum 1:2006 and Technical Corrigendum 2:2008

Publisher:
Canada National Standard/Canadian Standards - ISO/IEC

Document status:

Active

Format:

Electronic (PDF)

Delivery time:

10 minutes

Delivery time (for Russian version):

200 business days

SKU:

This is a text searchable PDF

1 Scope

This part of International Standard ISO/IEC 9075 specifies the syntax and semantics of a database language for declaring and maintaining persistent database language routines in SQL-server modules.

The database language for externally-invoked procedures andSQL-invoked routine>s includes: - The specification of statements to direct the flow of control. - The assignment of the result of expressions to variables and parameters. - The specification of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution. - The specification of statements to signal and resignal conditions. - The declaration of local cursors. - The declaration of local variables.

It also includes the definition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.

File Size :	1 file , 7.7 MB
Number of Pages :	189
Published :	12/01/2004

CAN/CSA-ISO/IEC 4/4/9075 PDF

Information Technology - Database Languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) (Adopted ISO/IEC 9075-4:2003, third edition, 2003-12-15), Includes Technical Corrigendum 1:2006 and Technical Corrigendum 2:2008

History

Related products

Best-Selling Products